package com.zhazha.stand.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.zhazha.stand.entity.UserScore;

public interface UserScoreMapper {
	
	public List<UserScore> getByUserId(@Param("userId")int UserId);
	
	public List<UserScore> getByContestId(@Param("contestId")int contestId);
	
	public List<UserScore> getByLevelAndContestId(@Param("level")int level, @Param("contestId")int contestId);
	
	public List<UserScore> getByUserIdAndContestId(@Param("userId")int userId, @Param("contestId")int contestId);
	
	public List<UserScore> getList();
	
	public int insert(UserScore userscore);
	
	public int update(UserScore userScore);
	
	public int deleteByUserId(int userId);
	
	public int deleteByContestId(int contestId);
	
	public int deleteByLevelAndContestId(@Param("level")int level, @Param("contestId")int contestId);
	
	public int deleteByUserIdAndContestId(@Param("userId")int userId, @Param("contestId")int contestId);

}
